﻿CREATE TABLE [dbo].[Consultatii] (
    [IdCons]               INT            IDENTITY (1, 1) NOT NULL,
    [IdPersoana]           INT            NOT NULL,
    [Data]                 DATETIME       CONSTRAINT [DF_Consultatii_Data] DEFAULT (getdate()) NOT NULL,
    [Motivele_prezentarii] VARCHAR (1000) NULL,
    [ExamenClinic]         VARCHAR (500)  NULL,
    [ExamenLaborator]      VARCHAR (500)  NULL,
    [Ecografie]            VARCHAR (1000) NULL,
    [Cistoscopie]          VARCHAR (1000) NULL,
    [Diagnostic]           VARCHAR (2000) NULL,
    [Reteta]               VARCHAR (3000) NULL,
    [TratamentRecomandat]  VARCHAR (1000) NULL,
    [TratamentEfectuat]    VARCHAR (1000) NULL,
    [AlteInformatii]       VARCHAR (1000) NULL,
    [Anamneza]             VARCHAR (500)  NULL,
    [FactoriDeRisc]        VARCHAR (500)  NULL,
    [DopplerVenos]         VARCHAR (500)  DEFAULT ('') NULL,
    [DopplerArterial]      VARCHAR (500)  DEFAULT ('') NULL,
    [DopplerCarotidian]    VARCHAR (500)  DEFAULT ('') NULL,
    [HolterTA]             VARCHAR (500)  DEFAULT ('') NULL,
    [EKG]                  VARCHAR (500)  DEFAULT ('') NULL,
    [HolterECG]            VARCHAR (500)  DEFAULT ('') NULL,
    CONSTRAINT [PK_Consultatii] PRIMARY KEY CLUSTERED ([IdCons] ASC),
    CONSTRAINT [FK_Consultatii_Persoane] FOREIGN KEY ([IdPersoana]) REFERENCES [dbo].[Persoane] ([IdPersoana])
);

